create procedure [dbo].[BAEErrorGetAll] @sortId as
int
AS
    IF(@sortId = 1)
        BEGIN
            SELECT * FROM Error
            ORDER BY ErrorID asC;
        END
    ELSE IF(@sortId = 2)
        BEGIN
            SELECT * FROM Error
            ORDER BY FriendlyErrorMessage asC;
        END
    ELSE IF(@sortId = 3)
        BEGIN
            SELECT * FROM Error
            ORDER BY FriendlyErrorMessage DESC;
        END
    ELSE IF(@sortId = 4)
        BEGIN
            SELECT * FROM Error
            ORDER BY UserID asC;
        END
    ELSE IF(@sortId = 5)
        BEGIN
            SELECT * FROM Error
            ORDER BY UserID DESC;
        END
    ELSE
        BEGIN
            SELECT * FROM Error
            ORDER BY ErrorID DESC;
        END

GO